package com.trkj.dao.cf;

import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.Certificate;

public interface CertificateDAO extends CrudRepository<Certificate, Long> {
	/*@Query("select c.certiId,z.zszlName,c.certiName,c.certiOwnertype,c.certiBorrowstate,"
			+ "c.certiUsestate,c.certiEffectivedate,c.certiPerson from Certificate c "
			+ "inner join c.zszlType z where c.certiName like ?1 or c.certiId like ?1")		
			List<Object[]>  queryBycertiName(String certiName,Pageable p);*/
}
